Overview

Dataset info

Number of variables90
Number of observations2968
Missing cells87159 (32.6%)
Duplicate rows0 (0.0%)
Total size in memory1.1 MiB
Average record size in memory400.0 B

Variables types

Numeric4
Categorical67
Boolean0
Date0
URL0
Text (Unique)4
Rejected15
Unsupported0

Warnings

ADDITIVES_BRANDED_DIESEL_IND has constant value "Y" Rejected
ADDITIVES_BRANDED_GASOLINE_IND has constant value "Y" Rejected
ADDITIVES_DYE_IND has constant value "Y" Rejected
ADDITIVES_LUBRICITY_IND has constant value "Y" Rejected
ADDITIVES_UNBRANDED_GASOLINE_IND has constant value "Y" Rejected
CF3030_LINE_CODE has 106 (< 0.1%) missing values Missing
CF3030_LINE_DESC has 105 (< 0.1%) missing values Missing
CF3030_LINE_LVL1_DESC has 105 (< 0.1%) missing values Missing
CF3030_LINE_LVL2_DESC has 105 (< 0.1%) missing values Missing
CONTAINER_REQUIREMENTS has a high cardinality: 112 distinct values Warning
CONTAINER_REQUIREMENTS has 2554 (86.1%) missing values Missing
EMAPSS_MATERIAL has a high cardinality: 847 distinct values Warning
EMAPSS_MATERIAL has 2122 (71.5%) missing values Missing
GOM_MATERIAL is highly skewed (γ1 = -24.454) Skewed
GOM_MATERIAL has 2370 (79.9%) missing values Missing
GPAQS_CMCS_CODE has a high cardinality: 680 distinct values Warning
GPAQS_CMCS_CODE has 2033 (68.5%) missing values Missing
GPAQS_MATERIAL_NAME has a high cardinality: 656 distinct values Warning
GPAQS_MATERIAL_NAME has 2036 (68.6%) missing values Missing
LS_GLOBAL_BRAND has constant value "XOM" Rejected
LS_GLOBAL_BRAND_DESC has constant value "ExxonMobil" Rejected
LS_GLOBAL_BULK_PACK_ID has 159 (5.4%) missing values Missing
LS_GLOBAL_PACKAGE_GROUP has 158 (5.3%) missing values Missing
LS_GLOBAL_PREMIUM_IND has 1997 (67.3%) missing values Missing
LS_GLOBAL_PREMIUM_IND_DESC has constant value "None" Rejected
LS_GLOBAL_PROD_FAMILY has 1997 (67.3%) missing values Missing
LS_GLOBAL_PROD_FAMILY_DESC has 1997 (67.3%) missing values Missing
LS_GLOBAL_PRODUCT_GROUP has 1997 (67.3%) missing values Missing
LS_GLOBAL_PRODUCT_GROUP_DESC has 1997 (67.3%) missing values Missing
LS_GLOBAL_PRODUCT_LINE has 1996 (67.3%) missing values Missing
LS_GLOBAL_PRODUCT_LINE_DESC has 1997 (67.3%) missing values Missing
LS_GLOBAL_PRODUCT_NUMBER has 1996 (67.3%) missing values Missing
LS_GLOBAL_SYNTHETIC_IND has constant value "MIN" Rejected
LS_GLOBAL_SYNTHETIC_IND_DESC has constant value "Mineral" Rejected
MATERIAL_DEL_IND has 2639 (88.9%) missing values Missing
MATERIAL_DESC has a high cardinality: 2916 distinct values Warning
MATERIAL_DESC has 39 (< 0.1%) missing values Missing
MATERIAL_DIVISION has 33 (< 0.1%) missing values Missing
MATERIAL_GROSS_WEIGHT has a high cardinality: 344 distinct values Warning
MATERIAL_GROUP has 36 (< 0.1%) missing values Missing
MATERIAL_GROUP_DESC has 99 (< 0.1%) missing values Missing
MATERIAL_NET_WEIGHT has a high cardinality: 247 distinct values Warning
MATERIAL_PROD_FAMILY_BLENDED has 1461 (49.2%) missing values Missing
MATERIAL_PROD_FAMILY_BLENDED_DESC has 1464 (49.3%) missing values Missing
MATERIAL_PROD_FAMILY_BLENDED_GROUP has 1464 (49.3%) missing values Missing
MATERIAL_PROD_FAMILY_UNBLENDED has 1462 (49.3%) missing values Missing
MATERIAL_PROD_FAMILY_UNBLENDED_DESC has 1464 (49.3%) missing values Missing
MATERIAL_PROD_FAMILY_UNBLENDED_GROUP has 1464 (49.3%) missing values Missing
MATERIAL_SOURCE_SYSTEM has constant value "nan" Rejected
MATERIAL_STCC has 2407 (81.1%) missing values Missing
MATERIAL_STCC_DESC has 2407 (81.1%) missing values Missing
MATERIAL_TYPE has 32 (< 0.1%) missing values Missing
MATERIAL_TYPE_DESC has 32 (< 0.1%) missing values Missing
MATERIAL_UOM has 32 (< 0.1%) missing values Missing
MATERIAL_VOL has a high cardinality: 352 distinct values Warning
PROD_HIER has a high cardinality: 55 distinct values Warning
PROD_HIER has 71 (< 0.1%) missing values Missing
PROD_LVL1 has 71 (< 0.1%) missing values Missing
PROD_LVL1_NO has 71 (< 0.1%) missing values Missing
PROD_LVL2 has 105 (< 0.1%) missing values Missing
PROD_LVL2_NO is highly correlated with PROD_LVL1_NO (ρ = 0.99999) Rejected
PROD_LVL3 has 105 (< 0.1%) missing values Missing
PROD_LVL3_NO has 105 (< 0.1%) missing values Missing
PROD_LVL4 has 118 (< 0.1%) missing values Missing
PROD_LVL4_NO has 118 (< 0.1%) missing values Missing
PROD_LVL5 has 1826 (61.5%) missing values Missing
PROD_LVL5_NO has 1825 (61.5%) missing values Missing
PROD_LVL6 has 2966 (> 99.9%) missing values Missing
PROD_LVL6_NO has constant value "nan" Rejected
SHIPNET_COMMODITY has constant value "nan" Rejected
TRANSPORT_GROUP has 113 (< 0.1%) missing values Missing
VOL_UOM_CODE has 112 (< 0.1%) missing values Missing
VR_CLASS_LVL1 has 194 (6.5%) missing values Missing
VR_CLASS_LVL1_NO has constant value "VR9999" Rejected
VR_CLASS_LVL2 has 194 (6.5%) missing values Missing
VR_CLASS_LVL2_NO has 194 (6.5%) missing values Missing
VR_CLASS_LVL3 has 194 (6.5%) missing values Missing
VR_CLASS_LVL3_NO has 194 (6.5%) missing values Missing
VR_CLASS_LVL4 has a high cardinality: 101 distinct values Warning
VR_CLASS_LVL4 has 194 (6.5%) missing values Missing
VR_CLASS_LVL4_NO has a high cardinality: 102 distinct values Warning
VR_CLASS_LVL4_NO has 194 (6.5%) missing values Missing
WEIGHT_UOM_CODE has 32 (< 0.1%) missing values Missing

Variables

ADDITIVES_BRANDED_DIESEL_IND
Constant

This variable is constant and should be ignored for analysis

Constant valueY

ADDITIVES_BRANDED_GASOLINE_IND
Constant

This variable is constant and should be ignored for analysis

Constant valueY

ADDITIVES_DYE_IND
Constant

This variable is constant and should be ignored for analysis

Constant valueY

ADDITIVES_LUBRICITY_IND
Constant

This variable is constant and should be ignored for analysis

Constant valueY

ADDITIVES_UNBRANDED_GASOLINE_IND
Constant

This variable is constant and should be ignored for analysis

Constant valueY

CF3030_LINE_CODE
Numeric

Distinct count11
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)106
Infinite (%)0.0%
Infinite (n)0
Mean192.67
Minimum10
Maximum9999
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum10
5-th percentile40
Q140
Median85
Q3260
95-th percentile270
Maximum9999
Range9989
Interquartile range220

Descriptive statistics

Standard deviation579.36
Coef of variation3.007
Kurtosis255.86
Mean192.67
MAD159.25
Skewness15.345
Sum5.5142e+05
Variance3.3566e+05
Memory size23.2 KiB
Histogram
ValueCountFrequency (%) 
260 912 30.7%
 
40 848 28.6%
 
85 812 27.4%
 
999 92 < 0.1%
 
270 52 < 0.1%
 
125 49 < 0.1%
 
160 45 < 0.1%
 
10 34 < 0.1%
 
195 9 < 0.1%
 
9999 9 < 0.1%
 
(Missing) 106 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
10 34 < 0.1%
 
40 848 28.6%
 
85 812 27.4%
 
125 49 < 0.1%
 
160 45 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
9999 9 < 0.1%
 
999 92 < 0.1%
 
270 52 < 0.1%
 
260 912 30.7%
 
195 9 < 0.1%
 

CF3030_LINE_DESC
Categorical

Distinct count12
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)105
Finished Lubes
912
Motor Gasoline
848
Distillate Fuels
812
Other values (8)
291
(Missing)
 
105
ValueCountFrequency (%) 
Finished Lubes 912 30.7%
 
Motor Gasoline 848 28.6%
 
Distillate Fuels 812 27.4%
 
Unassigned Classes 92 < 0.1%
 
Lubes - Basestocks 52 < 0.1%
 
Fuel Oil 49 < 0.1%
 
Liquified Pet Gas 45 < 0.1%
 
Aviation Fuels 34 < 0.1%
 
Undefined 9 < 0.1%
 
Ref Gas & Other Pet 9 < 0.1%
 
(Missing) 105 < 0.1%
 
Max length19
Mean length14.295
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

CF3030_LINE_LVL1_DESC
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)105
Products
2761
Unassigned Classes
 
92
Undefined
 
9
(Missing)
 
105
ValueCountFrequency (%) 
Products 2761 93.0%
 
Unassigned Classes 92 < 0.1%
 
Undefined 9 < 0.1%
 
Crude 1 < 0.1%
 
(Missing) 105 < 0.1%
 
Max length18
Mean length8.1351
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

CF3030_LINE_LVL2_DESC
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)105
Fuels
1797
Lubes
964
Unassigned Classes
 
92
Other values (2)
 
10
(Missing)
 
105
ValueCountFrequency (%) 
Fuels 1797 60.5%
 
Lubes 964 32.5%
 
Unassigned Classes 92 < 0.1%
 
Undefined 9 < 0.1%
 
Crude 1 < 0.1%
 
(Missing) 105 < 0.1%
 
Max length18
Mean length5.3443
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

CONTAINER_REQUIREMENTS
Categorical

Distinct count112
Unique (%)< 0.1%
Missing (%)86.1%
Missing (n)2554
9B
 
77
7B
 
49
4B
 
34
Other values (108)
 
254
(Missing)
2554
ValueCountFrequency (%) 
9B 77 < 0.1%
 
7B 49 < 0.1%
 
4B 34 < 0.1%
 
7L 20 < 0.1%
 
1N 13 < 0.1%
 
5P 10 < 0.1%
 
1B 9 < 0.1%
 
4N 8 < 0.1%
 
6T 8 < 0.1%
 
4M 7 < 0.1%
 
Other values (101) 179 6.0%
 
(Missing) 2554 86.1%
 
Max length3
Mean length2.8605
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

DH_SRC
Categorical

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
STRIPES_AM
2929
DSDW_W7
 
39
ValueCountFrequency (%) 
STRIPES_AM 2929 > 99.9%
 
DSDW_W7 39 < 0.1%
 
Max length10
Mean length9.9606
Min length7
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

EMAPSS_MATERIAL
Categorical

Distinct count847
Unique (%)28.5%
Missing (%)71.5%
Missing (n)2122
125105
 
1
110528
 
1
121902
 
1
Other values (843)
843
(Missing)
2122
ValueCountFrequency (%) 
125105 1 < 0.1%
 
110528 1 < 0.1%
 
121902 1 < 0.1%
 
100795 1 < 0.1%
 
102342 1 < 0.1%
 
120524 1 < 0.1%
 
103683 1 < 0.1%
 
121275 1 < 0.1%
 
123508 1 < 0.1%
 
103659 1 < 0.1%
 
Other values (836) 836 28.2%
 
(Missing) 2122 71.5%
 
Max length6
Mean length3.8544
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

FUELS_BASE_IND
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Base
2559
Premium
 
408
Crude
 
1
ValueCountFrequency (%) 
Base 2559 86.2%
 
Premium 408 13.7%
 
Crude 1 < 0.1%
 
Max length7
Mean length4.4127
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

GLOB_PROD_LVL1
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Fuels Finished Petroleum Product
1743
Refy Oth External Input
1141
Refinery Processed Input
 
79
ValueCountFrequency (%) 
Fuels Finished Petroleum Product 1743 58.7%
 
Refy Oth External Input 1141 38.4%
 
Refinery Processed Input 79 < 0.1%
 
Byproducts 5 < 0.1%
 
Max length32
Mean length28.29
Min length10
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

GLOB_PROD_LVL1_NO
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
30
1743
20
1141
10
 
79
ValueCountFrequency (%) 
30 1743 58.7%
 
20 1141 38.4%
 
10 79 < 0.1%
 
50 5 < 0.1%
 
Max length2
Mean length2
Min length2
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

GLOB_PROD_LVL2
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Clean Products
1684
Non-Proc Refy Inputs
1141
Post-PS Feedstocks
 
79
Other values (2)
 
64
ValueCountFrequency (%) 
Clean Products 1684 56.7%
 
Non-Proc Refy Inputs 1141 38.4%
 
Post-PS Feedstocks 79 < 0.1%
 
Fuel Oils 59 < 0.1%
 
Solids 5 < 0.1%
 
Max length20
Mean length16.3
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

GLOB_PROD_LVL2_NO
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
20
1684
18
1141
16
 
79
Other values (2)
 
64
ValueCountFrequency (%) 
20 1684 56.7%
 
18 1141 38.4%
 
16 79 < 0.1%
 
31 59 < 0.1%
 
A7 5 < 0.1%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

GLOB_PROD_LVL3
Categorical

Distinct count11
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Additives
1141
Motor Gasoline
822
Land Diesel
711
Other values (8)
294
ValueCountFrequency (%) 
Additives 1141 38.4%
 
Motor Gasoline 822 27.7%
 
Land Diesel 711 24.0%
 
Processed Chem Rtns 79 < 0.1%
 
Heating Oil 68 < 0.1%
 
Fuel Oil - Marine 59 < 0.1%
 
Marine Distillates 28 < 0.1%
 
Jet 26 < 0.1%
 
Other Petroleum 19 < 0.1%
 
Kerosene 10 < 0.1%
 
Max length19
Mean length11.417
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

GLOB_PROD_LVL3_NO
Categorical

Distinct count11
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
38
1141
50
822
51
711
Other values (8)
294
ValueCountFrequency (%) 
38 1141 38.4%
 
50 822 27.7%
 
51 711 24.0%
 
30 79 < 0.1%
 
54 68 < 0.1%
 
61 59 < 0.1%
 
55 28 < 0.1%
 
53 26 < 0.1%
 
56 19 < 0.1%
 
58 10 < 0.1%
 
Max length2
Mean length2
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

GLOB_PROD_LVL4
Categorical

Distinct count31
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Fuels Additives
1108
Regular ADO
559
Regular
306
Other values (28)
995
ValueCountFrequency (%) 
Fuels Additives 1108 37.3%
 
Regular ADO 559 18.8%
 
Regular 306 10.3%
 
Premium 256 8.6%
 
Intermediate 140 < 0.1%
 
Premium ADO 129 < 0.1%
 
Mogas Discounts Rebates Cards Oth 118 < 0.1%
 
Oth Proc Non-SC Rtns 52 < 0.1%
 
Regular Sulphur Fuel Oil - Marine 40 < 0.1%
 
Regular Heating Oil 37 < 0.1%
 
Other values (21) 223 7.5%
 
Max length34
Mean length13.78
Min length6
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

GLOB_PROD_LVL4_NO
Categorical

Distinct count31
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
381
1108
512
559
503
306
Other values (28)
995
ValueCountFrequency (%) 
381 1108 37.3%
 
512 559 18.8%
 
503 306 10.3%
 
501 256 8.6%
 
502 140 < 0.1%
 
511 129 < 0.1%
 
506 118 < 0.1%
 
305 52 < 0.1%
 
611 40 < 0.1%
 
541 37 < 0.1%
 
Other values (21) 223 7.5%
 
Max length3
Mean length3
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

GOM_MATERIAL
Numeric

Distinct count458
Unique (%)15.4%
Missing (%)79.9%
Missing (n)2370
Infinite (%)0.0%
Infinite (n)0
Mean8.9872e+07
Minimum7
Maximum9.004e+07
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum7
5-th percentile9.0007e+07
Q19.0011e+07
Median9.0025e+07
Q39.0039e+07
95-th percentile9.004e+07
Maximum9.004e+07
Range9.004e+07
Interquartile range28029

Descriptive statistics

Standard deviation3.6813e+06
Coef of variation0.040962
Kurtosis597.99
Mean8.9872e+07
MAD3.0058e+05
Skewness-24.454
Sum5.3744e+10
Variance1.3552e+13
Memory size23.2 KiB
Histogram
ValueCountFrequency (%) 
9.0027e+07 9 < 0.1%
 
9.0014e+07 8 < 0.1%
 
9.0025e+07 8 < 0.1%
 
9.0025e+07 8 < 0.1%
 
9.0027e+07 7 < 0.1%
 
9.0014e+07 7 < 0.1%
 
9.0007e+07 6 < 0.1%
 
9.0007e+07 5 < 0.1%
 
9.0011e+07 4 < 0.1%
 
9.0007e+07 4 < 0.1%
 
Other values (447) 532 17.9%
 
(Missing) 2370 79.9%
 

Minimum 5 values

ValueCountFrequency (%) 
7 1 < 0.1%
 
9.0003e+07 1 < 0.1%
 
9.0003e+07 1 < 0.1%
 
9.0003e+07 1 < 0.1%
 
9.0003e+07 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
9.004e+07 1 < 0.1%
 
9.004e+07 1 < 0.1%
 
9.004e+07 1 < 0.1%
 
9.004e+07 1 < 0.1%
 
9.004e+07 1 < 0.1%
 

GPAQS_CMCS_CODE
Categorical

Distinct count680
Unique (%)22.9%
Missing (%)68.5%
Missing (n)2033
97BD53
 
6
97AF78
 
6
97F356
 
6
Other values (676)
917
(Missing)
2033
ValueCountFrequency (%) 
97BD53 6 < 0.1%
 
97AF78 6 < 0.1%
 
97F356 6 < 0.1%
 
97CH73 5 < 0.1%
 
97F179 5 < 0.1%
 
97AS51 4 < 0.1%
 
97F587 4 < 0.1%
 
97V336 4 < 0.1%
 
97BB16 4 < 0.1%
 
97P468 4 < 0.1%
 
Other values (669) 887 29.9%
 
(Missing) 2033 68.5%
 
Max length9
Mean length3.9586
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

GPAQS_MATERIAL_NAME
Categorical

Distinct count656
Unique (%)22.1%
Missing (%)68.6%
Missing (n)2036
RED DYE LIQUID
 
6
OLOA 249SX
 
6
AUTOMATE RED 9BHF
 
6
Other values (652)
914
(Missing)
2036
ValueCountFrequency (%) 
RED DYE LIQUID 6 < 0.1%
 
OLOA 249SX 6 < 0.1%
 
AUTOMATE RED 9BHF 6 < 0.1%
 
OLOA 275JR 5 < 0.1%
 
ADEKA SAKURALUBE 515 5 < 0.1%
 
OLOA 219M 5 < 0.1%
 
INFINEUM SV150 (FORMERLY SAP 150/SHELLVIS 50) 5 < 0.1%
 
DITERTIARY-BUTYL-PARACRESOL 4 < 0.1%
 
INFINEUM V387 (FORMERLY PARAFLOW 387) 4 < 0.1%
 
LUBRIZOL 5515A 4 < 0.1%
 
Other values (645) 882 29.7%
 
(Missing) 2036 68.6%
 
Max length61
Mean length7.4555
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

LS_GLOBAL_BRAND
Constant

This variable is constant and should be ignored for analysis

Constant valueXOM

LS_GLOBAL_BRAND_DESC
Constant

This variable is constant and should be ignored for analysis

Constant valueExxonMobil

LS_GLOBAL_BULK_PACK_ID
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)5.4%
Missing (n)159
BULK
2176
PACK
633
(Missing)
 
159
ValueCountFrequency (%) 
BULK 2176 73.3%
 
PACK 633 21.3%
 
(Missing) 159 5.4%
 
Max length4
Mean length3.9464
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

LS_GLOBAL_PACKAGE_GROUP
Categorical

Distinct count11
Unique (%)< 0.1%
Missing (%)5.3%
Missing (n)158
BULK
2174
DRUM
486
OTH
 
81
Other values (7)
 
69
(Missing)
 
158
ValueCountFrequency (%) 
BULK 2174 73.2%
 
DRUM 486 16.4%
 
OTH 81 < 0.1%
 
KEG 28 < 0.1%
 
PAIL 25 < 0.1%
 
BOLG 5 < 0.1%
 
TOTE 4 < 0.1%
 
BOSM 3 < 0.1%
 
IBC 3 < 0.1%
 
BIN 1 < 0.1%
 
(Missing) 158 5.3%
 
Max length4
Mean length3.9087
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

LS_GLOBAL_PREMIUM_IND
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)67.3%
Missing (n)1997
NON
958
OTHER
 
13
(Missing)
1997
ValueCountFrequency (%) 
NON 958 32.3%
 
OTHER 13 < 0.1%
 
(Missing) 1997 67.3%
 
Max length5
Mean length3.0088
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

LS_GLOBAL_PREMIUM_IND_DESC
Constant

This variable is constant and should be ignored for analysis

Constant valueNone

LS_GLOBAL_PROD_FAMILY
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)67.3%
Missing (n)1997
STOCK
966
BASEOI
 
5
(Missing)
1997
ValueCountFrequency (%) 
STOCK 966 32.5%
 
BASEOI 5 < 0.1%
 
(Missing) 1997 67.3%
 
Max length6
Mean length3.656
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

LS_GLOBAL_PROD_FAMILY_DESC
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)67.3%
Missing (n)1997
STOCK
966
BASE OILS
 
5
(Missing)
1997
ValueCountFrequency (%) 
STOCK 966 32.5%
 
BASE OILS 5 < 0.1%
 
(Missing) 1997 67.3%
 
Max length9
Mean length3.6611
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

LS_GLOBAL_PRODUCT_GROUP
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)67.3%
Missing (n)1997
OTHER
966
BOOTH
 
5
(Missing)
1997
ValueCountFrequency (%) 
OTHER 966 32.5%
 
BOOTH 5 < 0.1%
 
(Missing) 1997 67.3%
 
Max length5
Mean length3.6543
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

LS_GLOBAL_PRODUCT_GROUP_DESC
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)67.3%
Missing (n)1997
OTHER
966
OTHER BASE OILS
 
5
(Missing)
1997
ValueCountFrequency (%) 
OTHER 966 32.5%
 
OTHER BASE OILS 5 < 0.1%
 
(Missing) 1997 67.3%
 
Max length15
Mean length3.6712
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

LS_GLOBAL_PRODUCT_LINE
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)67.3%
Missing (n)1996
ADD
967
BO
 
4
CRUDE - EUROPE - NO. SEA
 
1
(Missing)
1996
ValueCountFrequency (%) 
ADD 967 32.6%
 
BO 4 < 0.1%
 
CRUDE - EUROPE - NO. SEA 1 < 0.1%
 
(Missing) 1996 67.3%
 
Max length24
Mean length3.0057
Min length2
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

LS_GLOBAL_PRODUCT_LINE_DESC
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)67.3%
Missing (n)1997
Additive
967
Base Oils
 
4
(Missing)
1997
ValueCountFrequency (%) 
Additive 967 32.6%
 
Base Oils 4 < 0.1%
 
(Missing) 1997 67.3%
 
Max length9
Mean length4.6371
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

LS_GLOBAL_PRODUCT_NUMBER
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)67.3%
Missing (n)1996
1010B06020
939
3010201040
 
14
3010202005
 
13
Other values (4)
 
6
(Missing)
1996
ValueCountFrequency (%) 
1010B06020 939 31.6%
 
3010201040 14 < 0.1%
 
3010202005 13 < 0.1%
 
3.0102E+11 2 < 0.1%
 
973408 2 < 0.1%
 
3010201010 1 < 0.1%
 
BULK 1 < 0.1%
 
(Missing) 1996 67.3%
 
Max length10
Mean length5.2877
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

LS_GLOBAL_SYNTHETIC_IND
Constant

This variable is constant and should be ignored for analysis

Constant valueMIN

LS_GLOBAL_SYNTHETIC_IND_DESC
Constant

This variable is constant and should be ignored for analysis

Constant valueMineral

MATERIAL
Categorical, Unique

First 5 values
100008
100033
100035
100038
100046
Last 5 values
RS_UNDEF_PROD1
RS_UNDEF_PROD2
RS_UNDEF_PROD3
RS_UNDEF_PROD4
RS_UNDEF_PROD5

First 5 values

ValueCountFrequency (%) 
100008 1 < 0.1%
 
100033 1 < 0.1%
 
100035 1 < 0.1%
 
100038 1 < 0.1%
 
100046 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
RS_UNDEF_PROD5 1 < 0.1%
 
RS_UNDEF_PROD4 1 < 0.1%
 
RS_UNDEF_PROD3 1 < 0.1%
 
RS_UNDEF_PROD2 1 < 0.1%
 
RS_UNDEF_PROD1 1 < 0.1%
 

MATERIAL_DEL_IND
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)88.9%
Missing (n)2639
X
 
328
90000187
 
1
(Missing)
2639
ValueCountFrequency (%) 
X 328 11.1%
 
90000187 1 < 0.1%
 
(Missing) 2639 88.9%
 
Max length8
Mean length2.7807
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

MATERIAL_DESC
Categorical

Distinct count2916
Unique (%)> 99.9%
Missing (%)< 0.1%
Missing (n)39
DO NOT USE
 
8
STOCK 1202.0BULKMETHYL 12-HYDROXYSTEAR
 
2
REBATE BUSINESS CARD
 
2
Other values (2912)
2917
(Missing)
 
39
ValueCountFrequency (%) 
DO NOT USE 8 < 0.1%
 
STOCK 1202.0BULKMETHYL 12-HYDROXYSTEAR 2 < 0.1%
 
REBATE BUSINESS CARD 2 < 0.1%
 
STOCK 1315.055.1158LBQUINIZARIN 2 < 0.1%
 
STOCK 1087100 KG MOLY DISULFIDE (EAME) 2 < 0.1%
 
STOCK 70229 417LB OLOA 42015 2 < 0.1%
 
METHANOL 2 < 0.1%
 
FUEL DISCOUNT - GASOLINE 2 < 0.1%
 
STOCK 5932.0BULKDCI-30N. 1 < 0.1%
 
EXXON S15 NO2 DIESEL EFFICIENT WNTR B5 1 < 0.1%
 
Other values (2905) 2905 > 99.9%
 
(Missing) 39 < 0.1%
 
Max length40
Mean length28.521
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

MATERIAL_DESC_CONCAT
Categorical, Unique

First 5 values
100008 STOCK 1335.5NALCO 5403 JET CORR INHIBIT
100033 STOCK 1443.0BULKLZ 948.
100035 STOCK 2216.0BULKLOBASE C4506.
100038 STOCK 0999.0BULKWATER.
100046 PRICE_REF: 89 CONV 3.5%O2 BRANDED.
Last 5 values
RS_UNDEF_PROD1
RS_UNDEF_PROD2
RS_UNDEF_PROD3
RS_UNDEF_PROD4
RS_UNDEF_PROD5

First 5 values

ValueCountFrequency (%) 
100008 STOCK 1335.5NALCO 5403 JET CORR INHIBIT 1 < 0.1%
 
100033 STOCK 1443.0BULKLZ 948. 1 < 0.1%
 
100035 STOCK 2216.0BULKLOBASE C4506. 1 < 0.1%
 
100038 STOCK 0999.0BULKWATER. 1 < 0.1%
 
100046 PRICE_REF: 89 CONV 3.5%O2 BRANDED. 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
RS_UNDEF_PROD5 1 < 0.1%
 
RS_UNDEF_PROD4 1 < 0.1%
 
RS_UNDEF_PROD3 1 < 0.1%
 
RS_UNDEF_PROD2 1 < 0.1%
 
RS_UNDEF_PROD1 1 < 0.1%
 

MATERIAL_DH_UPDATE_TIMESTAMP
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
09:24.0
2960
00:03.0
 
2
37:48.0
 
2
Other values (4)
 
4
ValueCountFrequency (%) 
09:24.0 2960 > 99.9%
 
00:03.0 2 < 0.1%
 
37:48.0 2 < 0.1%
 
11:01.0 1 < 0.1%
 
03:35.0 1 < 0.1%
 
101313 1 < 0.1%
 
02:40.0 1 < 0.1%
 
Max length7
Mean length6.9997
Min length6
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

MATERIAL_DIVISION
Numeric

Distinct count9
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)33
Infinite (%)0.0%
Infinite (n)0
Mean3.1131
Minimum2
Maximum13
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile2
Q12
Median2
Q34
95-th percentile6
Maximum13
Range11
Interquartile range2

Descriptive statistics

Standard deviation1.6757
Coef of variation0.53827
Kurtosis6.1142
Mean3.1131
MAD1.3021
Skewness2.1436
Sum9137
Variance2.8079
Memory size23.2 KiB
Histogram
ValueCountFrequency (%) 
2 1716 57.8%
 
4 973 32.8%
 
8 81 < 0.1%
 
6 74 < 0.1%
 
9 50 < 0.1%
 
5 24 < 0.1%
 
13 10 < 0.1%
 
3 7 < 0.1%
 
(Missing) 33 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
2 1716 57.8%
 
3 7 < 0.1%
 
4 973 32.8%
 
5 24 < 0.1%
 
6 74 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
13 10 < 0.1%
 
9 50 < 0.1%
 
8 81 < 0.1%
 
6 74 < 0.1%
 
5 24 < 0.1%
 

MATERIAL_GROSS_WEIGHT
Categorical

Distinct count344
Unique (%)11.6%
Missing (%)< 0.1%
Missing (n)1
1
455
850.768
 
335
1,000
 
206
Other values (340)
1971
ValueCountFrequency (%) 
1 455 15.3%
 
850.768 335 11.3%
 
1,000 206 6.9%
 
0 105 < 0.1%
 
878.328 76 < 0.1%
 
850 70 < 0.1%
 
750 69 < 0.1%
 
739.329 58 < 0.1%
 
851.606 58 < 0.1%
 
746.519 54 < 0.1%
 
Other values (333) 1481 49.9%
 
Max length8
Mean length4.782
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

MATERIAL_GROUP
Categorical

Distinct count29
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)36
MOGAS
693
LSP-ADD
645
DIESEL
589
Other values (25)
1005
ValueCountFrequency (%) 
MOGAS 693 23.3%
 
LSP-ADD 645 21.7%
 
DIESEL 589 19.8%
 
LSB-ADD 289 9.7%
 
ZZ-PRICE 106 < 0.1%
 
3530 84 < 0.1%
 
PRDENV 70 < 0.1%
 
CLEAN-OTH 70 < 0.1%
 
3520 65 < 0.1%
 
GASOIL 64 < 0.1%
 
Other values (18) 257 8.7%
 
Max length9
Mean length6.0492
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

MATERIAL_GROUP_DESC
Categorical

Distinct count28
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)99
PH3=101010
693
Lube Additive Pack
645
PH3=101020
589
Other values (24)
942
ValueCountFrequency (%) 
PH3=101010 693 23.3%
 
Lube Additive Pack 645 21.7%
 
PH3=101020 589 19.8%
 
Lube Additive Bulk 289 9.7%
 
PH3=101010 PRDNN=PRICE REF: 106 < 0.1%
 
Fuel Adds Other (HitecKerobit TPKerobit BPDColours/dyes) 84 < 0.1%
 
PH3=706015 70 < 0.1%
 
PH3=602030 70 < 0.1%
 
Gasoline Additives (incl. Lead Compound) 65 < 0.1%
 
PH3=101060 64 < 0.1%
 
Other values (17) 194 6.5%
 
(Missing) 99 < 0.1%
 
Max length60
Mean length15.068
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

MATERIAL_KEY
Categorical, Unique

First 5 values
100008
100033
100035
100038
100046
Last 5 values
RS_UNDEF_PROD1
RS_UNDEF_PROD2
RS_UNDEF_PROD3
RS_UNDEF_PROD4
RS_UNDEF_PROD5

First 5 values

ValueCountFrequency (%) 
100008 1 < 0.1%
 
100033 1 < 0.1%
 
100035 1 < 0.1%
 
100038 1 < 0.1%
 
100046 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
RS_UNDEF_PROD5 1 < 0.1%
 
RS_UNDEF_PROD4 1 < 0.1%
 
RS_UNDEF_PROD3 1 < 0.1%
 
RS_UNDEF_PROD2 1 < 0.1%
 
RS_UNDEF_PROD1 1 < 0.1%
 

MATERIAL_MD
Categorical, Unique

First 5 values
100008
100033
100035
100038
100046
Last 5 values
RS_UNDEF_PROD1
RS_UNDEF_PROD2
RS_UNDEF_PROD3
RS_UNDEF_PROD4
RS_UNDEF_PROD5

First 5 values

ValueCountFrequency (%) 
100008 1 < 0.1%
 
100033 1 < 0.1%
 
100035 1 < 0.1%
 
100038 1 < 0.1%
 
100046 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
RS_UNDEF_PROD5 1 < 0.1%
 
RS_UNDEF_PROD4 1 < 0.1%
 
RS_UNDEF_PROD3 1 < 0.1%
 
RS_UNDEF_PROD2 1 < 0.1%
 
RS_UNDEF_PROD1 1 < 0.1%
 

MATERIAL_NET_WEIGHT
Categorical

Distinct count247
Unique (%)8.3%
Missing (%)0.0%
Missing (n)0
1
966
850.768
335
1,000
 
200
Other values (244)
1467
ValueCountFrequency (%) 
1 966 32.5%
 
850.768 335 11.3%
 
1,000 200 6.7%
 
0 112 < 0.1%
 
878.328 76 < 0.1%
 
850 70 < 0.1%
 
750 69 < 0.1%
 
851.606 58 < 0.1%
 
739.329 58 < 0.1%
 
746.519 54 < 0.1%
 
Other values (237) 970 32.7%
 
Max length8
Mean length4.1223
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

MATERIAL_PROD_FAMILY_BLENDED
Categorical

Distinct count21
Unique (%)< 0.1%
Missing (%)49.2%
Missing (n)1461
ULSD
569
PREMCBOB
 
153
REGCBOB
 
150
Other values (17)
635
(Missing)
1461
ValueCountFrequency (%) 
ULSD 569 19.2%
 
PREMCBOB 153 5.2%
 
REGCBOB 150 5.1%
 
MIDCBOB 93 < 0.1%
 
REGRFG 88 < 0.1%
 
PREMRFG 70 < 0.1%
 
DISTBLENDSTK 58 < 0.1%
 
MIDRFG 49 < 0.1%
 
REGCBOBSUM 48 < 0.1%
 
ULSD1 45 < 0.1%
 
Other values (10) 184 6.2%
 
(Missing) 1461 49.2%
 
Max length13
Mean length4.621
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

MATERIAL_PROD_FAMILY_BLENDED_DESC
Categorical

Distinct count19
Unique (%)< 0.1%
Missing (%)49.3%
Missing (n)1464
ULSD
569
Premium CBOB
 
153
Regular CBOB
 
150
Other values (15)
632
(Missing)
1464
ValueCountFrequency (%) 
ULSD 569 19.2%
 
Premium CBOB 153 5.2%
 
Regular CBOB 150 5.1%
 
Mid-Grade CBOB 93 < 0.1%
 
Regular RFG 88 < 0.1%
 
Premium RFG 70 < 0.1%
 
DISTILLATE BLENDSTOCK 58 < 0.1%
 
Mid-Grade RFG 49 < 0.1%
 
Regular CBOB SUMMER GRADE 48 < 0.1%
 
ULSD1 45 < 0.1%
 
Other values (8) 181 6.1%
 
(Missing) 1464 49.3%
 
Max length27
Mean length6.5081
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

MATERIAL_PROD_FAMILY_BLENDED_GROUP
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)49.3%
Missing (n)1464
Mogas
721
Distillate
689
Components
 
61
(Missing)
1464
ValueCountFrequency (%) 
Mogas 721 24.3%
 
Distillate 689 23.2%
 
Components 61 < 0.1%
 
Jet 33 < 0.1%
 
(Missing) 1464 49.3%
 
Max length10
Mean length5.2547
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

MATERIAL_PROD_FAMILY_UNBLENDED
Categorical

Distinct count16
Unique (%)< 0.1%
Missing (%)49.3%
Missing (n)1462
ULSD
569
REGCBOB
 
198
PREMCBOB
 
191
Other values (12)
548
(Missing)
1462
ValueCountFrequency (%) 
ULSD 569 19.2%
 
REGCBOB 198 6.7%
 
PREMCBOB 191 6.4%
 
# 170 5.7%
 
REGRFG 88 < 0.1%
 
PREMRFG 70 < 0.1%
 
DISTBLENDSTK 58 < 0.1%
 
ULSD1 45 < 0.1%
 
HEATOIL 37 < 0.1%
 
JET 33 < 0.1%
 
Other values (5) 47 < 0.1%
 
(Missing) 1462 49.3%
 
Max length13
Mean length4.1772
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

MATERIAL_PROD_FAMILY_UNBLENDED_DESC
Categorical

Distinct count15
Unique (%)< 0.1%
Missing (%)49.3%
Missing (n)1464
ULSD
569
Regular CBOB
 
198
Premium CBOB
 
191
Other values (11)
546
(Missing)
1464
ValueCountFrequency (%) 
ULSD 569 19.2%
 
Regular CBOB 198 6.7%
 
Premium CBOB 191 6.4%
 
# 170 5.7%
 
Regular RFG 88 < 0.1%
 
Premium RFG 70 < 0.1%
 
DISTILLATE BLENDSTOCK 58 < 0.1%
 
ULSD1 45 < 0.1%
 
Heating Oil 37 < 0.1%
 
Jet 33 < 0.1%
 
Other values (4) 45 < 0.1%
 
(Missing) 1464 49.3%
 
Max length21
Mean length5.2807
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

MATERIAL_PROD_FAMILY_UNBLENDED_GROUP
Categorical

Distinct count6
Unique (%)< 0.1%
Missing (%)49.3%
Missing (n)1464
Distillate
689
Mogas
551
#
 
170
Other values (2)
 
94
(Missing)
1464
ValueCountFrequency (%) 
Distillate 689 23.2%
 
Mogas 551 18.6%
 
# 170 5.7%
 
Components 61 < 0.1%
 
Jet 33 < 0.1%
 
(Missing) 1464 49.3%
 
Max length10
Mean length5.0256
Min length1
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsTrue

MATERIAL_SOURCE_SYSTEM
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

MATERIAL_STCC
Numeric

Distinct count31
Unique (%)< 0.1%
Missing (%)81.1%
Missing (n)2407
Infinite (%)0.0%
Infinite (n)0
Mean3.3802e+06
Minimum1.4716e+06
Maximum4.9616e+06
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1.4716e+06
5-th percentile2.8999e+06
Q12.9e+06
Median2.9113e+06
Q32.9912e+06
95-th percentile4.9122e+06
Maximum4.9616e+06
Range3.49e+06
Interquartile range91239

Descriptive statistics

Standard deviation8.5606e+05
Coef of variation0.25326
Kurtosis-0.44842
Mean3.3802e+06
MAD7.2558e+05
Skewness1.2128
Sum1.8963e+09
Variance7.3284e+11
Memory size23.2 KiB
Histogram
ValueCountFrequency (%) 
2.9114e+06 98 < 0.1%
 
2.9113e+06 93 < 0.1%
 
2.8999e+06 84 < 0.1%
 
4.9082e+06 84 < 0.1%
 
2.9e+06 79 < 0.1%
 
4.9122e+06 40 < 0.1%
 
2.9112e+06 34 < 0.1%
 
2.9912e+06 8 < 0.1%
 
2.9118e+06 8 < 0.1%
 
2.9111e+06 5 < 0.1%
 
Other values (20) 28 < 0.1%
 
(Missing) 2407 81.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1.4716e+06 1 < 0.1%
 
2.8133e+06 1 < 0.1%
 
2.8184e+06 1 < 0.1%
 
2.8211e+06 1 < 0.1%
 
2.8999e+06 84 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4.9616e+06 1 < 0.1%
 
4.9602e+06 1 < 0.1%
 
4.921e+06 1 < 0.1%
 
4.9153e+06 1 < 0.1%
 
4.9148e+06 1 < 0.1%
 

MATERIAL_STCC_DESC
Categorical

Distinct count30
Unique (%)< 0.1%
Missing (%)81.1%
Missing (n)2407
PETROLEUM LUBRICATING OIL
 
98
PETROLEUM DISTILLATE FUEL OIL DIESEL OIL OR GAS OIL NOT SUITABLE FOR ILLUMINATING PURPOSES
 
93
GASOLINE
 
84
Other values (26)
 
286
(Missing)
2407
ValueCountFrequency (%) 
PETROLEUM LUBRICATING OIL 98 < 0.1%
 
PETROLEUM DISTILLATE FUEL OIL DIESEL OIL OR GAS OIL NOT SUITABLE FOR ILLUMINATING PURPOSES 93 < 0.1%
 
GASOLINE 84 < 0.1%
 
ADDITIVES FUEL OIL GASOLINE OR LUBRICATING OIL CONTAINING LESS THAN 50 PERCENT BY WEIGHT OF PETROLEUM 84 < 0.1%
 
CHEMICALS NEC 79 < 0.1%
 
DIESEL FUEL 40 < 0.1%
 
GASOLINE NEC 34 < 0.1%
 
PETROLEUM OIL ADDITIVE CONTAINING MORE THAN 50 PERCENT BY WEIGHT OF PETROLEUM 8 < 0.1%
 
OIL PETROLEUM NEC 8 < 0.1%
 
JET FUEL 5 < 0.1%
 
Other values (19) 28 < 0.1%
 
(Missing) 2407 81.1%
 
Max length101
Mean length10.424
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

MATERIAL_TYPE
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)32
HALB
2863
DIEN
 
67
SERV
 
6
(Missing)
 
32
ValueCountFrequency (%) 
HALB 2863 > 99.9%
 
DIEN 67 < 0.1%
 
SERV 6 < 0.1%
 
(Missing) 32 < 0.1%
 
Max length4
Mean length3.9892
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

MATERIAL_TYPE_DESC
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)32
Semifinished product
2862
Service
 
67
Brand Fund Agreement
 
6
(Missing)
 
32
ValueCountFrequency (%) 
Semifinished product 2862 > 99.9%
 
Service 67 < 0.1%
 
Brand Fund Agreement 6 < 0.1%
 
896.1 1 < 0.1%
 
(Missing) 32 < 0.1%
 
Max length20
Mean length19.518
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

MATERIAL_UOM
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)32
M15
1747
KG
965
EA
 
79
Other values (4)
 
145
ValueCountFrequency (%) 
M15 1747 58.9%
 
KG 965 32.5%
 
EA 79 < 0.1%
 
TO 73 < 0.1%
 
D43 70 < 0.1%
 
BBL 1 < 0.1%
 
UGL 1 < 0.1%
 
(Missing) 32 < 0.1%
 
Max length3
Mean length2.6237
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

MATERIAL_VOL
Categorical

Distinct count352
Unique (%)11.9%
Missing (%)0.0%
Missing (n)0
1,000
1788
0
 
112
1.113
 
37
Other values (349)
1031
ValueCountFrequency (%) 
1,000 1788 60.2%
 
0 112 < 0.1%
 
1.113 37 < 0.1%
 
1 20 < 0.1%
 
3.785 17 < 0.1%
 
1.043 15 < 0.1%
 
1.001 13 < 0.1%
 
1.084 12 < 0.1%
 
0.973 12 < 0.1%
 
1,009.08 11 < 0.1%
 
Other values (342) 931 31.4%
 
Max length20
Mean length4.8706
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

PROD_HIER
Categorical

Distinct count55
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)71
1010B06020
939
10102080
373
10102015
 
209
Other values (51)
1376
ValueCountFrequency (%) 
1010B06020 939 31.6%
 
10102080 373 12.6%
 
10102015 209 7.0%
 
1010B06010 170 5.7%
 
10101050 164 5.5%
 
10101010 149 5.0%
 
10101055 131 < 0.1%
 
10101015 129 < 0.1%
 
10101035 103 < 0.1%
 
70601510 67 < 0.1%
 
Other values (44) 463 15.6%
 
(Missing) 71 < 0.1%
 
Max length14
Mean length8.5745
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

PROD_LVL1
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)71
Fin.Petr Prod ex Lu
2679
Non-Petroleum
 
104
Raw materials/Unfin.
 
81
(Missing)
 
71
ValueCountFrequency (%) 
Fin.Petr Prod ex Lu 2679 90.3%
 
Non-Petroleum 104 < 0.1%
 
Raw materials/Unfin. 81 < 0.1%
 
LUBE BASE OILS 33 < 0.1%
 
(Missing) 71 < 0.1%
 
Max length20
Mean length18.379
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

PROD_LVL1_NO
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)71
10
2679
70
 
104
60
 
81
(Missing)
 
71
ValueCountFrequency (%) 
10 2679 90.3%
 
70 104 < 0.1%
 
60 81 < 0.1%
 
30 33 < 0.1%
 
(Missing) 71 < 0.1%
 
Max length4
Mean length3.9761
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

PROD_LVL2
Categorical

Distinct count7
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)105
CP&S ex Lubes
2628
Feed/Blendst. clean
 
80
Other Non-Petroleum
 
70
Other values (3)
 
85
(Missing)
 
105
ValueCountFrequency (%) 
CP&S ex Lubes 2628 88.5%
 
Feed/Blendst. clean 80 < 0.1%
 
Other Non-Petroleum 70 < 0.1%
 
Fuel Oils 51 < 0.1%
 
BASE OILS 33 < 0.1%
 
Crude 1 < 0.1%
 
(Missing) 105 < 0.1%
 
Max length19
Mean length12.834
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

PROD_LVL2_NO
Highly correlated

This variable is highly correlated with PROD_LVL1_NO and should be ignored for analysis

Correlation0.99999

PROD_LVL3
Categorical

Distinct count14
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)105
Chemicals
1114
Motor Gasoline
749
Diesel
637
Other values (10)
363
(Missing)
 
105
ValueCountFrequency (%) 
Chemicals 1114 37.5%
 
Motor Gasoline 749 25.2%
 
Diesel 637 21.5%
 
Other clean fd/blst 80 < 0.1%
 
Fuels Env Credits 70 < 0.1%
 
Gasoil - Land 64 < 0.1%
 
Fuel Oil - Marine 51 < 0.1%
 
NON-XOM MAN BASEOILS 33 < 0.1%
 
Jet 25 < 0.1%
 
Gasoil - Marine 18 < 0.1%
 
Other values (3) 22 < 0.1%
 
(Missing) 105 < 0.1%
 
Max length20
Mean length10.239
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

PROD_LVL3_NO
Categorical

Distinct count14
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)105
0000001010B0
1114
101010
749
101020
637
Other values (10)
363
(Missing)
 
105
ValueCountFrequency (%) 
0000001010B0 1114 37.5%
 
101010 749 25.2%
 
101020 637 21.5%
 
602030 80 < 0.1%
 
706015 70 < 0.1%
 
101060 64 < 0.1%
 
102020 51 < 0.1%
 
301020 33 < 0.1%
 
101040 25 < 0.1%
 
101065 18 < 0.1%
 
Other values (3) 22 < 0.1%
 
(Missing) 105 < 0.1%
 
Max length12
Mean length8.1701
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

PROD_LVL4
Categorical

Distinct count46
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)118
Additives
1109
Regular ADO with Bio
373
Regular ADO
 
209
Other values (42)
1159
ValueCountFrequency (%) 
Additives 1109 37.4%
 
Regular ADO with Bio 373 12.6%
 
Regular ADO 209 7.0%
 
Regular UL 164 5.5%
 
Premium UL 149 5.0%
 
Regular UL w Eth 131 < 0.1%
 
Premium UL with Eth 129 < 0.1%
 
Intermediate UL w Eth 103 < 0.1%
 
RINS 67 < 0.1%
 
Intermediate UL 66 < 0.1%
 
Other values (35) 350 11.8%
 
(Missing) 118 < 0.1%
 
Max length25
Mean length12.174
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

PROD_LVL4_NO
Categorical

Distinct count47
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)118
00001010B060
1109
10102080
373
10102015
 
209
Other values (43)
1159
ValueCountFrequency (%) 
00001010B060 1109 37.4%
 
10102080 373 12.6%
 
10102015 209 7.0%
 
10101050 164 5.5%
 
10101010 149 5.0%
 
10101055 131 < 0.1%
 
10101015 129 < 0.1%
 
10101035 103 < 0.1%
 
70601510 67 < 0.1%
 
10101030 66 < 0.1%
 
Other values (36) 350 11.8%
 
(Missing) 118 < 0.1%
 
Max length12
Mean length9.3187
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

PROD_LVL5
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)61.5%
Missing (n)1826
Lubes Additives
939
Fuels Additives
 
170
OTHER GROUP I
 
15
Other values (4)
 
18
(Missing)
1826
ValueCountFrequency (%) 
Lubes Additives 939 31.6%
 
Fuels Additives 170 5.7%
 
OTHER GROUP I 15 < 0.1%
 
OTHER GROUP II 13 < 0.1%
 
BRIGHTSTOCK 2 < 0.1%
 
LIGHT NEUTRAL 2 < 0.1%
 
HEAVY NEUTRAL 1 < 0.1%
 
(Missing) 1826 61.5%
 
Max length15
Mean length7.598
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

PROD_LVL5_NO
Categorical

Distinct count9
Unique (%)< 0.1%
Missing (%)61.5%
Missing (n)1825
001010B06020
939
001010B06010
 
170
3010201040
 
15
Other values (5)
 
19
(Missing)
1825
ValueCountFrequency (%) 
001010B06020 939 31.6%
 
001010B06010 170 5.7%
 
3010201040 15 < 0.1%
 
3010202005 13 < 0.1%
 
3010201010 2 < 0.1%
 
3010201030 2 < 0.1%
 
3010201020 1 < 0.1%
 
NorthSea 1 < 0.1%
 
(Missing) 1825 61.5%
 
Max length12
Mean length6.4427
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

PROD_LVL6
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)> 99.9%
Missing (n)2966
Chevron Neutral Oil 220R
 
1
AMERICAS SN 100 LV
 
1
(Missing)
2966
ValueCountFrequency (%) 
Chevron Neutral Oil 220R 1 < 0.1%
 
AMERICAS SN 100 LV 1 < 0.1%
 
(Missing) 2966 > 99.9%
 
Max length24
Mean length3.0121
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

PROD_LVL6_NO
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

PROMIS_SHELF_LIFE
Categorical

Distinct count22
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
2068
720
435
1,440
 
97
Other values (19)
 
368
ValueCountFrequency (%) 
0 2068 69.7%
 
720 435 14.7%
 
1,440 97 < 0.1%
 
1,080 87 < 0.1%
 
3,520 74 < 0.1%
 
360 68 < 0.1%
 
1,800 66 < 0.1%
 
540 22 < 0.1%
 
730 12 < 0.1%
 
1,620 9 < 0.1%
 
Other values (12) 30 < 0.1%
 
Max length5
Mean length1.8332
Min length1
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

SHIPNET_COMMODITY
Constant

This variable is constant and should be ignored for analysis

Constant valuenan

TRANSPORT_GROUP
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)113
RBLK
2178
RPCK
677
(Missing)
 
113
ValueCountFrequency (%) 
RBLK 2178 73.4%
 
RPCK 677 22.8%
 
(Missing) 113 < 0.1%
 
Max length4
Mean length3.9619
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

VOL_UOM_CODE
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)112
L15
2854
L
 
1
1,000
 
1
(Missing)
 
112
ValueCountFrequency (%) 
L15 2854 > 99.9%
 
L 1 < 0.1%
 
1,000 1 < 0.1%
 
(Missing) 112 < 0.1%
 
Max length5
Mean length3
Min length1
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

VR_CLASS_LVL1
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)6.5%
Missing (n)194
VOLUME REPORTING
2773
VR9999
 
1
(Missing)
 
194
ValueCountFrequency (%) 
VOLUME REPORTING 2773 93.4%
 
VR9999 1 < 0.1%
 
(Missing) 194 6.5%
 
Max length16
Mean length15.147
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

VR_CLASS_LVL1_NO
Constant

This variable is constant and should be ignored for analysis

Constant valueVR9999

VR_CLASS_LVL2
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)6.5%
Missing (n)194
LUBES
964
MOGAS
845
DISTILLATES
816
Other values (4)
 
149
(Missing)
194
ValueCountFrequency (%) 
LUBES 964 32.5%
 
MOGAS 845 28.5%
 
DISTILLATES 816 27.5%
 
OTHER 95 < 0.1%
 
OTHER PRODUCTS 33 < 0.1%
 
GAS LIQUIDS 20 < 0.1%
 
VR2699 1 < 0.1%
 
(Missing) 194 6.5%
 
Max length14
Mean length6.6597
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

VR_CLASS_LVL2_NO
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)6.5%
Missing (n)194
VR3999
964
VR5999
845
VR6999
816
Other values (4)
 
149
(Missing)
194
ValueCountFrequency (%) 
VR3999 964 32.5%
 
VR5999 845 28.5%
 
VR6999 816 27.5%
 
VR8999 95 < 0.1%
 
VR7999 33 < 0.1%
 
VR4999 20 < 0.1%
 
VOLUME REPORTING 1 < 0.1%
 
(Missing) 194 6.5%
 
Max length16
Mean length5.8073
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

VR_CLASS_LVL3
Categorical

Distinct count22
Unique (%)< 0.1%
Missing (%)6.5%
Missing (n)194
L06 LUBE-ADDITIVES
891
P09 FINISHED DISTILLATES
717
P05 UNLEADED
293
Other values (18)
873
ValueCountFrequency (%) 
L06 LUBE-ADDITIVES 891 30.0%
 
P09 FINISHED DISTILLATES 717 24.2%
 
P05 UNLEADED 293 9.9%
 
P03 SUPER 264 8.9%
 
P04 SPECIAL 174 5.9%
 
P06 OTHER MOGAS 109 < 0.1%
 
P10 OTHER DISTILLATE 99 < 0.1%
 
P13 BY PRODUCTS 55 < 0.1%
 
L01 LUBE-BLENDSTOCKS 52 < 0.1%
 
P14 REFINERY INPUT 37 < 0.1%
 
Other values (11) 83 < 0.1%
 
(Missing) 194 6.5%
 
Max length32
Mean length16.626
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

VR_CLASS_LVL3_NO
Categorical

Distinct count22
Unique (%)< 0.1%
Missing (%)6.5%
Missing (n)194
VR3499
891
VR6099
717
VR5299
293
Other values (18)
873
ValueCountFrequency (%) 
VR3499 891 30.0%
 
VR6099 717 24.2%
 
VR5299 293 9.9%
 
VR5099 264 8.9%
 
VR5199 174 5.9%
 
VR5499 109 < 0.1%
 
VR6199 99 < 0.1%
 
VR8099 55 < 0.1%
 
VR3099 52 < 0.1%
 
VR8599 37 < 0.1%
 
Other values (11) 83 < 0.1%
 
(Missing) 194 6.5%
 
Max length6
Mean length5.8036
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

VR_CLASS_LVL4
Categorical

Distinct count101
Unique (%)< 0.1%
Missing (%)6.5%
Missing (n)194
LUBE ADDITIVES
891
S15 MV NO.2 DSL
369
ADDITIVES
 
172
Other values (97)
1342
(Missing)
 
194
ValueCountFrequency (%) 
LUBE ADDITIVES 891 30.0%
 
S15 MV NO.2 DSL 369 12.4%
 
ADDITIVES 172 5.8%
 
S15 NRLM No.2 DSL 161 5.4%
 
UNLEADED CONVENTIONAL 97 < 0.1%
 
SUPER CONVENTIONAL 92 < 0.1%
 
SPECIAL CONVENTIONAL 57 < 0.1%
 
BASESTOCK - FINISHED 52 < 0.1%
 
RESID FUEL 49 < 0.1%
 
SUPER OXYW/ETHANOL 48 < 0.1%
 
Other values (90) 786 26.5%
 
(Missing) 194 6.5%
 
Max length40
Mean length16.033
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

VR_CLASS_LVL4_NO
Categorical

Distinct count102
Unique (%)< 0.1%
Missing (%)6.5%
Missing (n)194
VR3401
891
VR6013
369
VR6018
 
161
Other values (98)
1353
(Missing)
 
194
ValueCountFrequency (%) 
VR3401 891 30.0%
 
VR6013 369 12.4%
 
VR6018 161 5.4%
 
VR5402 109 < 0.1%
 
VR5201 97 < 0.1%
 
VR5001 92 < 0.1%
 
VR6101 63 < 0.1%
 
VR5101 57 < 0.1%
 
VR3001 52 < 0.1%
 
VR8001 49 < 0.1%
 
Other values (91) 834 28.1%
 
(Missing) 194 6.5%
 
Max length20
Mean length5.8086
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

WEIGHT_UOM_CODE
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)< 0.1%
Missing (n)32
KG
2935
L15
 
1
(Missing)
 
32
ValueCountFrequency (%) 
KG 2935 > 99.9%
 
L15 1 < 0.1%
 
(Missing) 32 < 0.1%
 
Max length3
Mean length2.0111
Min length2
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Correlations

Missing values

Matrix

Matrix

Count

Bar

Heatmap

Heatmap

Dendrogram

Dendrogram

Sample

First rows

ADDITIVES_BRANDED_DIESEL_INDADDITIVES_BRANDED_GASOLINE_INDADDITIVES_DYE_INDADDITIVES_LUBRICITY_INDADDITIVES_UNBRANDED_GASOLINE_INDCF3030_LINE_CODECF3030_LINE_DESCCF3030_LINE_LVL1_DESCCF3030_LINE_LVL2_DESCCONTAINER_REQUIREMENTSDH_SRCEMAPSS_MATERIALFUELS_BASE_INDGLOB_PROD_LVL1GLOB_PROD_LVL1_NOGLOB_PROD_LVL2GLOB_PROD_LVL2_NOGLOB_PROD_LVL3GLOB_PROD_LVL3_NOGLOB_PROD_LVL4GLOB_PROD_LVL4_NOGOM_MATERIALGPAQS_CMCS_CODEGPAQS_MATERIAL_NAMELS_GLOBAL_BRANDLS_GLOBAL_BRAND_DESCLS_GLOBAL_BULK_PACK_IDLS_GLOBAL_PACKAGE_GROUPLS_GLOBAL_PREMIUM_INDLS_GLOBAL_PREMIUM_IND_DESCLS_GLOBAL_PROD_FAMILYLS_GLOBAL_PROD_FAMILY_DESCLS_GLOBAL_PRODUCT_GROUPLS_GLOBAL_PRODUCT_GROUP_DESCLS_GLOBAL_PRODUCT_LINELS_GLOBAL_PRODUCT_LINE_DESCLS_GLOBAL_PRODUCT_NUMBERLS_GLOBAL_SYNTHETIC_INDLS_GLOBAL_SYNTHETIC_IND_DESCMATERIALMATERIAL_DEL_INDMATERIAL_DESCMATERIAL_DESC_CONCATMATERIAL_DH_UPDATE_TIMESTAMPMATERIAL_DIVISIONMATERIAL_GROSS_WEIGHTMATERIAL_GROUPMATERIAL_GROUP_DESCMATERIAL_KEYMATERIAL_MDMATERIAL_NET_WEIGHTMATERIAL_PROD_FAMILY_BLENDEDMATERIAL_PROD_FAMILY_BLENDED_DESCMATERIAL_PROD_FAMILY_BLENDED_GROUPMATERIAL_PROD_FAMILY_UNBLENDEDMATERIAL_PROD_FAMILY_UNBLENDED_DESCMATERIAL_PROD_FAMILY_UNBLENDED_GROUPMATERIAL_SOURCE_SYSTEMMATERIAL_STCCMATERIAL_STCC_DESCMATERIAL_TYPEMATERIAL_TYPE_DESCMATERIAL_UOMMATERIAL_VOLPROD_HIERPROD_LVL1PROD_LVL1_NOPROD_LVL2PROD_LVL2_NOPROD_LVL3PROD_LVL3_NOPROD_LVL4PROD_LVL4_NOPROD_LVL5PROD_LVL5_NOPROD_LVL6PROD_LVL6_NOPROMIS_SHELF_LIFESHIPNET_COMMODITYTRANSPORT_GROUPVOL_UOM_CODEVR_CLASS_LVL1VR_CLASS_LVL1_NOVR_CLASS_LVL2VR_CLASS_LVL2_NOVR_CLASS_LVL3VR_CLASS_LVL3_NOVR_CLASS_LVL4VR_CLASS_LVL4_NOWEIGHT_UOM_CODE
0NaNNaNNaNNaNNaN40.0Motor GasolineProductsFuelsNaNSTRIPES_AMNaNBaseRefy Oth External Input20Non-Proc Refy Inputs18Additives38Fuels Additives381NaNNaNNaNNaNNaNBULKBULKNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN100008NaNSTOCK 1335.5NALCO 5403 JET CORR INHIBIT100008 STOCK 1335.5NALCO 5403 JET CORR INHIBIT09:24.02.0874.7333530Fuel Adds Other (HitecKerobit TPKerobit BPDCol...100008100008874.733NaNNaNNaNNaNNaNNaNNaNNaNNaNHALBSemifinished productM151,0001010B06010Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Chemicals0000001010B0Additives00001010B060Fuels Additives001010B06010NaNNaN0NaNRBLKL15VOLUME REPORTINGVR9999MOGASVR5999P06 OTHER MOGASVR5499ADDITIVESVR5402KG
1NaNNaNNaNNaNNaN260.0Finished LubesProductsLubesNaNSTRIPES_AM100033BaseRefy Oth External Input20Non-Proc Refy Inputs18Additives38Fuels Additives38190039041.0970654LUBRIZOL 948XOMExxonMobilBULKBULKNONNoneSTOCKSTOCKOTHEROTHERADDAdditive1010B06020MINMineral100033NaNSTOCK 1443.0BULKLZ 948.100033 STOCK 1443.0BULKLZ 948.09:24.04.01LSB-ADDLube Additive Bulk1000331000331NaNNaNNaNNaNNaNNaNNaN2899885.0ADDITIVES FUEL OIL GASOLINE OR LUBRICATING OIL...HALBSemifinished productKG1.0771010B06020Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Chemicals0000001010B0Additives00001010B060Lubes Additives001010B06020NaNNaN720NaNRBLKL15VOLUME REPORTINGVR9999LUBESVR3999L06 LUBE-ADDITIVESVR3499LUBE ADDITIVESVR3401KG
2NaNNaNNaNNaNNaN260.0Finished LubesProductsLubesNaNSTRIPES_AM100035BaseRefy Oth External Input20Non-Proc Refy Inputs18Additives38Fuels Additives38190039042.0970122LOBASE C4506XOMExxonMobilBULKBULKNONNoneSTOCKSTOCKOTHEROTHERADDAdditive1010B06020MINMineral100035NaNSTOCK 2216.0BULKLOBASE C4506.100035 STOCK 2216.0BULKLOBASE C4506.09:24.04.01LSB-ADDLube Additive Bulk1000351000351NaNNaNNaNNaNNaNNaNNaN2911415.0PETROLEUM LUBRICATING OILHALBSemifinished productKG1.0581010B06020Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Chemicals0000001010B0Additives00001010B060Lubes Additives001010B06020NaNNaN1,080NaNRBLKL15VOLUME REPORTINGVR9999LUBESVR3999L06 LUBE-ADDITIVESVR3499LUBE ADDITIVESVR3401KG
3NaNNaNNaNNaNNaN260.0Finished LubesProductsLubesNaNSTRIPES_AM100038BaseRefy Oth External Input20Non-Proc Refy Inputs18Additives38Fuels Additives381NaN971391WATERXOMExxonMobilBULKBULKNONNoneSTOCKSTOCKOTHEROTHERADDAdditive1010B06020MINMineral100038NaNSTOCK 0999.0BULKWATER.100038 STOCK 0999.0BULKWATER.09:24.04.01LSB-ADDLube Additive Bulk1000381000381NaNNaNNaNNaNNaNNaNNaNNaNNaNHALBSemifinished productKG1.0031010B06020Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Chemicals0000001010B0Additives00001010B060Lubes Additives001010B06020NaNNaN3,520NaNRBLKL15VOLUME REPORTINGVR9999LUBESVR3999L08 LUBE-NO VALUE LUBES PRODUCTSVR3699WATER-NO VALUEVR3601KG
4NaNNaNNaNNaNNaN40.0Motor GasolineProductsFuelsNaNSTRIPES_AMNaNBaseFuels Finished Petroleum Product30Clean Products20Motor Gasoline50Intermediate502NaNNaNNaNNaNNaNBULKBULKNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN100046NaNPRICE_REF: 89 CONV 3.5%O2 BRANDED.100046 PRICE_REF: 89 CONV 3.5%O2 BRANDED.09:24.02.01,000ZZ-PRICEPH3=101010 PRDNN=PRICE REF:1000461000461,000NaNNaNNaNNaNNaNNaNNaNNaNNaNHALBSemifinished productM151,00010101035Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Motor Gasoline101010Intermediate UL w Eth10101035NaNNaNNaNNaN0NaNRBLKL15VOLUME REPORTINGVR9999MOGASVR5999P04 SPECIALVR5199SPECIAL RFG W/MTBEVR5105KG
5NaNNaNNaNNaNNaN40.0Motor GasolineProductsFuelsNaNSTRIPES_AMNaNBaseFuels Finished Petroleum Product30Clean Products20Motor Gasoline50Mogas Discounts Rebates Cards Oth506NaNNaNNaNNaNNaNBULKBULKNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN100050NaNPRICE_REF: 92 CONV 3.5%O2 BRANDED.100050 PRICE_REF: 92 CONV 3.5%O2 BRANDED.09:24.02.01,000ZZ-PRICEPH3=101010 PRDNN=PRICE REF:1000501000501,000PREMCBOBSUMPremium CBOB SUMMER GRADEMogasPREMCBOBPremium CBOBMogasNaNNaNNaNHALBSemifinished productM151,00010101015Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Motor Gasoline101010Premium UL with Eth10101015NaNNaNNaNNaN0NaNRBLKL15VOLUME REPORTINGVR9999MOGASVR5999P03 SUPERVR5099SUPER CONVENTIONAL - SUMMER BLENDVR5010KG
6NaNNaNNaNNaNNaN85.0Distillate FuelsProductsFuelsNaNSTRIPES_AMNaNBaseFuels Finished Petroleum Product30Clean Products20Land Diesel51Regular ADO512NaNNaNNaNNaNNaNBULKBULKNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN100053NaNPRICE_REF: NO.2 FUEL OIL DYED#180018.100053 PRICE_REF: NO.2 FUEL OIL DYED#180018.09:24.02.01,000ZZ-PRICEPH3=101010 PRDNN=PRICE REF:1000531000531,000NaNNaNNaNNaNNaNNaNNaNNaNNaNHALBSemifinished productM151,00010102015Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Diesel101020Regular ADO10102015NaNNaNNaNNaN0NaNRBLKL15VOLUME REPORTINGVR9999DISTILLATESVR6999P09 FINISHED DISTILLATESVR6099S>500 NRLM NO.2 DSLVR6007KG
7NaNNaNNaNNaNNaN40.0Motor GasolineProductsFuelsNaNSTRIPES_AMNaNBaseFuels Finished Petroleum Product30Clean Products20Motor Gasoline50Intermediate502NaNNaNNaNNaNNaNBULKBULKNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN100054NaNPRICE_REF: 89 OCT CONV BRANDED.100054 PRICE_REF: 89 OCT CONV BRANDED.09:24.02.01,000ZZ-PRICEPH3=101010 PRDNN=PRICE REF:1000541000541,000MIDCBOBMid-Grade CBOBMogas###NaNNaNNaNHALBSemifinished productM151,00010101030Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Motor Gasoline101010Intermediate UL10101030NaNNaNNaNNaN0NaNRBLKL15VOLUME REPORTINGVR9999MOGASVR5999P04 SPECIALVR5199SPECIAL CONVENTIONALVR5101KG
8NaNNaNNaNNaNNaN40.0Motor GasolineProductsFuelsNaNSTRIPES_AMNaNBaseFuels Finished Petroleum Product30Clean Products20Motor Gasoline50Regular503NaNNaNNaNNaNNaNBULKBULKNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN100056NaNPRICE_REF: 87 CONV 3.5%O2 BRANDED.100056 PRICE_REF: 87 CONV 3.5%O2 BRANDED.09:24.02.01,000ZZ-PRICEPH3=101010 PRDNN=PRICE REF:1000561000561,000NaNNaNNaNNaNNaNNaNNaNNaNNaNHALBSemifinished productM151,00010101055Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Motor Gasoline101010Regular UL w Eth10101055NaNNaNNaNNaN0NaNRBLKL15VOLUME REPORTINGVR9999MOGASVR5999P05 UNLEADEDVR5299UNLEADED RFG W/MTBEVR5205KG
9NaNNaNNaNNaNNaN85.0Distillate FuelsProductsFuelsNaNSTRIPES_AMNaNBaseFuels Finished Petroleum Product30Clean Products20Land Diesel51Regular ADO512NaNNaNNaNNaNNaNBULKBULKNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN100063NaNPRICE_REF: S500 LM NO.2 DSL ADD DYED.100063 PRICE_REF: S500 LM NO.2 DSL ADD DYED.09:24.02.01,000ZZ-PRICEPH3=101010 PRDNN=PRICE REF:1000631000631,000S500DSLS500 DieselDistillateS500DSLS500 DieselDistillateNaNNaNNaNHALBSemifinished productM151,00010102015Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Diesel101020Regular ADO10102015NaNNaNNaNNaN0NaNRBLKL15VOLUME REPORTINGVR9999DISTILLATESVR6999P09 FINISHED DISTILLATESVR6099S500 NRLM NO.2 DSLVR6017KG

Last rows

ADDITIVES_BRANDED_DIESEL_INDADDITIVES_BRANDED_GASOLINE_INDADDITIVES_DYE_INDADDITIVES_LUBRICITY_INDADDITIVES_UNBRANDED_GASOLINE_INDCF3030_LINE_CODECF3030_LINE_DESCCF3030_LINE_LVL1_DESCCF3030_LINE_LVL2_DESCCONTAINER_REQUIREMENTSDH_SRCEMAPSS_MATERIALFUELS_BASE_INDGLOB_PROD_LVL1GLOB_PROD_LVL1_NOGLOB_PROD_LVL2GLOB_PROD_LVL2_NOGLOB_PROD_LVL3GLOB_PROD_LVL3_NOGLOB_PROD_LVL4GLOB_PROD_LVL4_NOGOM_MATERIALGPAQS_CMCS_CODEGPAQS_MATERIAL_NAMELS_GLOBAL_BRANDLS_GLOBAL_BRAND_DESCLS_GLOBAL_BULK_PACK_IDLS_GLOBAL_PACKAGE_GROUPLS_GLOBAL_PREMIUM_INDLS_GLOBAL_PREMIUM_IND_DESCLS_GLOBAL_PROD_FAMILYLS_GLOBAL_PROD_FAMILY_DESCLS_GLOBAL_PRODUCT_GROUPLS_GLOBAL_PRODUCT_GROUP_DESCLS_GLOBAL_PRODUCT_LINELS_GLOBAL_PRODUCT_LINE_DESCLS_GLOBAL_PRODUCT_NUMBERLS_GLOBAL_SYNTHETIC_INDLS_GLOBAL_SYNTHETIC_IND_DESCMATERIALMATERIAL_DEL_INDMATERIAL_DESCMATERIAL_DESC_CONCATMATERIAL_DH_UPDATE_TIMESTAMPMATERIAL_DIVISIONMATERIAL_GROSS_WEIGHTMATERIAL_GROUPMATERIAL_GROUP_DESCMATERIAL_KEYMATERIAL_MDMATERIAL_NET_WEIGHTMATERIAL_PROD_FAMILY_BLENDEDMATERIAL_PROD_FAMILY_BLENDED_DESCMATERIAL_PROD_FAMILY_BLENDED_GROUPMATERIAL_PROD_FAMILY_UNBLENDEDMATERIAL_PROD_FAMILY_UNBLENDED_DESCMATERIAL_PROD_FAMILY_UNBLENDED_GROUPMATERIAL_SOURCE_SYSTEMMATERIAL_STCCMATERIAL_STCC_DESCMATERIAL_TYPEMATERIAL_TYPE_DESCMATERIAL_UOMMATERIAL_VOLPROD_HIERPROD_LVL1PROD_LVL1_NOPROD_LVL2PROD_LVL2_NOPROD_LVL3PROD_LVL3_NOPROD_LVL4PROD_LVL4_NOPROD_LVL5PROD_LVL5_NOPROD_LVL6PROD_LVL6_NOPROMIS_SHELF_LIFESHIPNET_COMMODITYTRANSPORT_GROUPVOL_UOM_CODEVR_CLASS_LVL1VR_CLASS_LVL1_NOVR_CLASS_LVL2VR_CLASS_LVL2_NOVR_CLASS_LVL3VR_CLASS_LVL3_NOVR_CLASS_LVL4VR_CLASS_LVL4_NOWEIGHT_UOM_CODE
2958NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNDSDW_W7NaNBaseFuels Finished Petroleum Product30Clean Products20Land Diesel51Other Distillate514NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNFM_OTHDISTNaNNaNFM_OTHDIST09:24.0NaN0NaNNaNFM_OTHDISTFM_OTHDIST0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2959NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNDSDW_W7NaNBaseFuels Finished Petroleum Product30Clean Products20Other Petroleum56Other Petroleum Fuels565NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNFM_OTHPPNaNNaNFM_OTHPP09:24.0NaN0NaNNaNFM_OTHPPFM_OTHPP0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2960NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNDSDW_W7NaNBaseFuels Finished Petroleum Product30Clean Products20Land Diesel51Other Engine Diesel513NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNFM_TDLHDNaNNaNFM_TDLHD09:24.0NaN0NaNNaNFM_TDLHDFM_TDLHD0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
2961NaNNaNNaNNaNNaN999.0Unassigned ClassesUnassigned ClassesUnassigned ClassesNaNDSDW_W7NaNBaseFuels Finished Petroleum Product30Clean Products20Motor Gasoline50Regular503NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNRS_LOGIST_PRNaNNaNRS_LOGIST_PR09:24.02.01,000MOGASPH3=101010RS_LOGIST_PRRS_LOGIST_PR0NaNNaNNaNNaNNaNNaNNaNNaNNaNHALBSemifinished productM15010101050Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Motor Gasoline101010Regular UL10101050NaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNKG
2962NaNNaNNaNNaNNaN999.0Unassigned ClassesUnassigned ClassesUnassigned ClassesNaNDSDW_W7NaNBaseFuels Finished Petroleum Product30Clean Products20Motor Gasoline50Regular503NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNRS_RGSPEARN_PRNaNNaNRS_RGSPEARN_PR09:24.02.01,000MOGASPH3=101010RS_RGSPEARN_PRRS_RGSPEARN_PR0NaNNaNNaNNaNNaNNaNNaNNaNNaNHALBSemifinished productM15010101050Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Motor Gasoline101010Regular UL10101050NaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNKG
2963NaNNaNNaNNaNNaN999.0Unassigned ClassesUnassigned ClassesUnassigned ClassesNaNDSDW_W7NaNBaseFuels Finished Petroleum Product30Clean Products20Motor Gasoline50Regular503NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNRS_UNDEF_PROD1NaNNaNRS_UNDEF_PROD109:24.02.01,000MOGASPH3=101010RS_UNDEF_PROD1RS_UNDEF_PROD10NaNNaNNaNNaNNaNNaNNaNNaNNaNHALBSemifinished productM15010101050Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Motor Gasoline101010Regular UL10101050NaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNKG
2964NaNNaNNaNNaNNaN999.0Unassigned ClassesUnassigned ClassesUnassigned ClassesNaNDSDW_W7NaNBaseFuels Finished Petroleum Product30Clean Products20Motor Gasoline50Regular503NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNRS_UNDEF_PROD2NaNNaNRS_UNDEF_PROD209:24.02.01,000MOGASPH3=101010RS_UNDEF_PROD2RS_UNDEF_PROD20NaNNaNNaNNaNNaNNaNNaNNaNNaNHALBSemifinished productM15010101050Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Motor Gasoline101010Regular UL10101050NaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNKG
2965NaNNaNNaNNaNNaN999.0Unassigned ClassesUnassigned ClassesUnassigned ClassesNaNDSDW_W7NaNBaseFuels Finished Petroleum Product30Clean Products20Motor Gasoline50Regular503NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNRS_UNDEF_PROD3NaNNaNRS_UNDEF_PROD309:24.02.01,000MOGASPH3=101010RS_UNDEF_PROD3RS_UNDEF_PROD30NaNNaNNaNNaNNaNNaNNaNNaNNaNHALBSemifinished productM15010101050Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Motor Gasoline101010Regular UL10101050NaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNKG
2966NaNNaNNaNNaNNaN999.0Unassigned ClassesUnassigned ClassesUnassigned ClassesNaNDSDW_W7NaNBaseFuels Finished Petroleum Product30Clean Products20Motor Gasoline50Regular503NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNRS_UNDEF_PROD4NaNNaNRS_UNDEF_PROD409:24.02.01,000MOGASPH3=101010RS_UNDEF_PROD4RS_UNDEF_PROD40NaNNaNNaNNaNNaNNaNNaNNaNNaNHALBSemifinished productM15010101050Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Motor Gasoline101010Regular UL10101050NaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNKG
2967NaNNaNNaNNaNNaN999.0Unassigned ClassesUnassigned ClassesUnassigned ClassesNaNDSDW_W7NaNBaseFuels Finished Petroleum Product30Clean Products20Motor Gasoline50Regular503NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNRS_UNDEF_PROD5NaNNaNRS_UNDEF_PROD509:24.02.01,000MOGASPH3=101010RS_UNDEF_PROD5RS_UNDEF_PROD50NaNNaNNaNNaNNaNNaNNaNNaNNaNHALBSemifinished productM15010101050Fin.Petr Prod ex Lu10.0CP&S ex Lubes1010.0Motor Gasoline101010Regular UL10101050NaNNaNNaNNaN0NaNNaNNaNNaNNaNNaNNaNNaNNaNNaNNaNKG